{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Disclaimer","Design Speed"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,3,10,8],[11,3,25,8],[21,10,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disclaimer"]
[]
[null,null,null,"This Design Calculation Spreadsheet is provided \"as-is\" without warranty of any kind. The Montana Department of Transportation makes no representations or warranties whatsoever with respect to the accuracy or completeness of this tool and assumes no responsibility for the suitability of this tool for a particular purpose; and MDT will not be liable for any damages incurred as a result of errors in this tool. \n\nBy selecting Accept, you are agreeing to these terms and conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WARNING: \nFor the tool to work properly, please make sure you click on \"Enable Content/Macros\" if the security warning appears."]

{"sheet":"Design Speed","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Rural"]
[null,"Functional Class","Rural Local Roads","Rural Freeways (NHS-Interstate)",{"$f":"IF($C$3=D3,1,\"ERROR\")","v":"ERROR"},{"$f":"IF($C$3=D3,IF($C$4=\"Level\",70,IF($C$4=\"Rolling\",70,IF($C$4=\"Mountainous\",50))),\"ERROR\")","v":"ERROR"}]
[null,"Terrain or Surface (Local)","Gravel","Rural Principal Arterials (NHS-Non Interstate)",{"$f":"IF($C$3=D4,1,\"ERROR\")","v":"ERROR"},{"$f":"IF($C$3=D4,IF($C$4=\"Level\",70,IF($C$4=\"Rolling\",60,IF($C$4=\"Mountainous\",50))),\"ERROR\")","v":"ERROR"}]
[null,"Design Speed (mph)",{"$f":"LOOKUP(1,E3:E7,F3:F7)","v":45},"Rural Minor Arterials (Non-NHS Primary)","ERROR",{"$f":"IF($C$3=D5,IF($C$4=\"Level\",60,IF($C$4=\"Rolling\",55,IF($C$4=\"Mountainous\",45))),\"ERROR\")","v":"ERROR"}]
[null,null,null,"Rural Collectors (Secondary System)","ERROR",{"$f":"IF($C$3=D6,IF($C$4=\"Level\",60,IF($C$4=\"Rolling\",50,IF($C$4=\"Mountainous\",45))),\"ERROR\")","v":"ERROR"}]
[null,null,null,"Rural Local Roads",1,{"$f":"IF($C$3=D7,IF($C$4=\"Paved\",50,IF($C$4=\"Gravel\",45)),\"ERROR\")","v":45}]
[null,"Urban"]
[null,"Functional Class","Urban Collector Streets","Urban Freeways (NHS-Interstate)",{"$f":"IF($C$9=D9,1,\"ERROR\")","v":"ERROR"},{"$f":"IF(E9=1,50,\"ERROR\")","v":"ERROR"}]
[null,"Design Speed (mph)",{"$f":"LOOKUP(1,E9:E12,F9:F12)","v":25},"Urban Principal Arterials (NHS-Non Interstate)",{"$f":"IF($C$9=D10,1,\"ERROR\")","v":"ERROR"},{"$f":"IF(E10=1,40,\"ERROR\")","v":"ERROR"}]
[null,null,null,"Urban Minor Arterials","ERROR",{"$f":"IF(E11=1,35,\"ERROR\")","v":"ERROR"}]
[null,null,null,"Urban Collector Streets",1,{"$f":"IF(E12=1,25,\"ERROR\")","v":25}]